package rsj.service.contract.dynamic;

import com.rlyy.aibase.utils.base.TableNode;
import org.springframework.stereotype.Component;

import java.util.List;

/**
 * 合同动态sql
 * @author yuanqinglong
 * @since 2021/8/4 10:59
 */
@Component
public class ContractDynamic {

    /**
     * 结合合同
     *
     * @param orgIds 机构id
     * @return {@link TableNode}
     */
   public String combinationContract(List<String> orgIds){
        return "SELECT orgp_org_id,orgp_id,orgp_status,orgp_billmethod,orgp_ctime,orgp_endtime,orgp_buyamount,orgp_useamount FROM sys.sys_orgp WHERE orgp_org_id IN (#{orgIds})";
    }
}
